# 从Excel文件获取受邀人单位和名字
from openpyxl import load_workbook
wb=load_workbook('chapter7/name_list.xlsx')
ws=wb['name']
names=[]
for row in range(2,ws.max_row+1):
    company= ws["A"+str(row)].value
    name= ws["B"+str(row)].value
    email = ws["C"+str(row)].value
    names.append(" {} {} {}".format(company,name,email))

print(names)